package kr.hkit.powerjava.chapter26;

import java.sql.Connection;
import java.util.Scanner;

import kr.hkit.powerjava.chapter26.common.ConnectionFactory;
import kr.hkit.powerjava.chapter26.common.DbUtil;
import kr.hkit.powerjava.chapter26.dto.Department;
import kr.hkit.powerjava.chapter26.dto.Employee;
import kr.hkit.powerjava.chapter26.service.AbsService;
import kr.hkit.powerjava.chapter26.service.DepartmentService;
import kr.hkit.powerjava.chapter26.service.EmployeeService;

public class Testmain {
	public static void main(String[] args) {
		Scanner sc = new Scanner(System.in);
		Connection connection = ConnectionFactory.getConnection();

		boolean flag = true;

		while (flag) {
			System.out.println("1.사원정보 2.부서정보 3.종료");
			switch (sc.nextInt()) {
			case 1:
				AbsService<Employee> empSvc = new EmployeeService(sc,
						connection);
				empSvc.prnMenu();
				break;
			case 2:
				AbsService<Department> deptSvc = new DepartmentService(sc,
						connection);
				deptSvc.prnMenu();
				break;

			default:
				flag = false;
				sc.close();
			}
			DbUtil.close(connection);
			/*
			 * AbsService<Employee> empSvc = new EmployeeService(sc,
			 * connection); empSvc.prnMenu();
			 */

			/*
			 * AbsService<Department> deptSvc = new DepartmentService(sc,
			 * connection); deptSvc.prnMenu();
			 */

			/*
			 * DepartmentDAO dao = new DepartmentDAO();
			 * 
			 * try { ArrayList<Department> list = dao.listItems();
			 * for(Department d : list){ System.out.println(d); } } catch
			 * (SQLException e) { e.printStackTrace(); }
			 * 
			 * Department d = new Department(6, "마케팅", 8); try {
			 * dao.insertItem(d); System.out.println("삽입 성공"); } catch
			 * (SQLException e) {
			 * System.err.println(e.getMessage()+":"+e.getErrorCode()); }
			 * 
			 * 
			 * try { d.setDeptName("교육"); //d.setFloor(9);
			 * dao.updateItemByNo(d); System.out.println("갱신 성공" + d); } catch
			 * (SQLException e1) {
			 * System.err.println(e1.getMessage()+":"+e1.getErrorCode()); }
			 */

			/*
			 * try { dao.deleteItemByNo(new Department(6));
			 * System.out.println("삭제 성공"); } catch (SQLException e) {
			 * e.printStackTrace(); }
			 */

			/*
			 * Connection con = ConnectionFactory.getConnection();
			 * 
			 * System.out.println(con);
			 * 
			 * String driver = "com.mysql.jdbc.Driver"; String url =
			 * "jdbc:mysql://localhost:3306/mysql_study"; String user = "root";
			 * String password = "1111";
			 * 
			 * DBProperties.savePropertis("dbcon.xml", driver, url, user,
			 * password);
			 * 
			 * 
			 * 
			 * Properties prop = DBProperties.loadPropertis("dbcon.xml");
			 * 
			 * DBProperties.prnProperties(prop);
			 */

			/*
			 * System.out.println(prop.getProperty("DRIVER"));
			 * System.out.println(prop.getProperty("URL"));
			 * System.out.println(prop.getProperty("USER"));
			 * System.out.println(prop.getProperty("PASSWORD"));
			 */

		}

	}
}
